package com.personendb.fotos.db;


public final class FotoTbl implements  FotoColumns {

	
  public static final String TABLE_NAME = "foto";

 
  public static final String SQL_CREATE =
      "CREATE TABLE "+TABLE_NAME+" (" +
      ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
      BEZEICHNUNG + " TEXT NOT NULL," +
      DATEINAME + " TEXT NOT NULL" +
      ");";

 
  public static final String SQL_DROP =
      "DROP TABLE IF EXISTS " +
      TABLE_NAME;

  
  public static final String STMT_INSERT_FULL =
      "INSERT INTO " +TABLE_NAME+
      "(" + BEZEICHNUNG + "," + DATEINAME + ") " +
      "VALUES (?,?)";

  
  public static final String STMT_DELETE_ALL =
      "DELETE "+TABLE_NAME;

  /**
   * SQL-Anweisung zur L&ouml;schung eines Fotos anhand
   * seines Schl&uuml;sselwerts.
   */
  public static final String STMT_DELETE_BY_ID =
      "DELETE  "+TABLE_NAME+
      " WHERE " + ID + " = ?";

 
  public static final String WHERE_ID_EQUALS =
      ID + "= ?";

 
  private FotoTbl() {
  }
}
